Insert To Db Before Outbound Call

[Guest Steve]

Hello, I already fourth time to ask this question :

 

 

 

I doing Marketing research, using telephone loader to call "998xxxxx"

My purpose is simple :

***Every dialed number need to insert to Database***

 

 

 

 

My script will insert the caller number to DB before playing the wave file.

=>> That OK, I have the record which number dialed.

 

 

And if a answer machine take my call, the answer machine script will also insert to DB,

=>> ***BUT the script will wait the AM message for long time, about 30 sec*** totally in one day my call performance will decrease ~60%

Before I using AM script, my machine can call 800 time per line. But after using it, only 300 call per line.

 

 

Last, I using a script "c:\market\notcall.vgs" that will also insert to DB that in the outdialque.mdb at the field "OnNotConnected".

=>> BUT I never see this script excuted. (already one week period.)

 

 

*************************************************************

Can I Just make Voiceguide run a script or insert the caller number, datetime (optional : answer by human, AM, not connect etc. ) to DB before/after every dialed call ?

*************************************************************

 

 

And the log file "market.csv" (in the c:\market, the same folder of running script), this is too complex, and I can't write a program that can import to my database.

 

Other way, the folder "C:\Program Files\VoiceGuide\data" have some "txt" file also is a log of dialed call, but the version I bought is 4 line version. Each line is hire by different client. So I think I also can't using it to import to each DB.

 

 

 

Thank you for your attention ~!

[SupportTeam]

I already fourth time to ask this question :

Where are the other forum threads in which you asked this question? It's probably best for you to continue with any questions you have within the same thread, instead of starting a new thread.

Last, I using a script "c:\market\notcall.vgs" that will also insert to DB that in the outdialque.mdb at the field "OnNotConnected".

=>> BUT I never see this script excuted. (already one week period.)

Which version of VoiceGuide are you using?

Can you post a trace capturing a call which was not connected and we can then see why the script was not executed...

Can I Just make Voiceguide run a script or insert the caller number, datetime (optional : answer by human, AM, not connect etc. ) to DB before/after every dialed call ?

Every call is queued through the OutDialQue database - you can have a copy of what was queued by setting up some stored procedures inside the database itself to copy every new added entry to your own copy table.

[Guest Steve]

Every call is queued through the OutDialQue database - you can have a copy of what was queued by setting up some stored procedures inside the database itself to copy every new added entry to your own copy table.

 

How can I set stored procedures in Access 200 ?

 

Thank you ~!

[SupportTeam]

MS Access has VBA scripting capabilities - methods available within it should allow you to achieve what you need.

 

You may also want to look at 'Replication' in MS Access Help.